Performance Evaluation of an Adaptive and Robust Load Control Method for the Avoidance of Data-Contention Thrashing
نویسندگان
چکیده
Load control is necessary to prevent a database system from data-contention or memory-contention thrashing, caused by excessive lock conflicts or excessive buffer replacements that may occur due to temporary load peaks. The load control method that is adopted by virtually all commercial database systems is to limit the degree of multiprogramming (DMP), that is, the maximum number of transactions that are allowed to execute concurrently. Severe shortcomings of this DMP method are that it requires manual tuning by the human system administrator, and that it cannot react to dynamic changes of the transaction mix in the workload. In this paper we present a performance evaluation of an adaptive, that is, self-tuning load control method for the avoidance of data-contention thrashing. The basic principle of this method is to monitor a data-contention performance metric called the conflict ratio, and to react to critical changes of the conflict ratio by temporarilysuspending the admission of newly arriving transactions or by cancelling blocked transactions that block other transactions. In order to show the practical viability of our method, we have performed a performance evaluation based on page reference traces from the on-line transaction processing system of a large Swiss bank. The adaptive load control method copes well with the dynamic load fluctuations of this workload. It clearly outperforms the DMP method, since it adapts the system to the dynamic changes of the transaction mix whereas the DMP method uses a fixed DMP as a (bad) compromise for the entire duration of the experiment.
منابع مشابه
Robust Adaptive Fuzzy Sliding Mode Control of Permanent Magnet Stepper Motor with Unknown Parameters and Load Torque
In this paper, robust adaptive fuzzy sliding mode control is designed to control the Permanent Magnet (PM) stepper motor in the presence of model uncertainties and disturbances. In doing so, the nonlinear model is converted to canonical form, then, for designing the controller, the robust sliding mode control is designed to decrease the effects of uncertainties and disturbances. A class of fuzz...
متن کاملEnergy Optimization of Under-actuated Crane model for Time-Variant Load Transferring using Optimized Adaptive Combined Hierarchical Sliding Mode Controller
This paper designs an Optimized Adaptive Combined Hierarchical Sliding Mode Controller (OACHSMC) for a time-varying crane model in presence of uncertainties. Uncertainties have always been one of the most important challenges in designing control systems, which include the unknown parameters or un-modeled dynamics in the systems. Sliding mode controller (SMC) is able to compensate the system in...
متن کاملAn Adaptive-Robust Control Approach for Trajectory Tracking of two 5 DOF Cooperating Robot Manipulators Moving a Rigid Payload
In this paper, a dual system consisting of two 5 DOF (RRRRR) robot manipulators is considered as a cooperative robotic system used to manipulate a rigid payload on a desired trajectory between two desired initial and end positions/orientations. The forward and inverse kinematic problems are first solved for the dual arm system. Then, dynamics of the system and the relations between forces/momen...
متن کاملDesigning a Robust Control Scheme for Robotic Systems with an Adaptive Observer
This paper introduces a robust task-space control scheme for a robotic system with an adaptive observer. The proposed approach does not require the availability of the system states and an adaptive observer is developed to estimate the state variables. These estimated states are then used in the control scheme. First, the dynamic model of a robot is derived. Next, an observer-based robust contr...
متن کامل